Pandas Profiling Report

Dataset statistics

Number of variables	18
Number of observations	2000
Missing cells	35
Missing cells (%)	0.1%
Duplicate rows	59
Duplicate rows (%)	2.9%
Total size in memory	281.4 KiB
Average record size in memory	144.1 B

Variable types

Unsupported	2
Numeric	13
Categorical	3

Alerts

Dataset has 59 (2.9%) duplicate rows	Duplicates
`genre` has a high cardinality: 59 distinct values	High cardinality
`explicit` is highly correlated with `speechiness` and 1 other fields	High correlation
`genre` is highly correlated with `explicit` and 3 other fields	High correlation
`energy` is highly correlated with `loudness` and 2 other fields	High correlation
`loudness` is highly correlated with `energy` and 1 other fields	High correlation
`speechiness` is highly correlated with `explicit`	High correlation
`acousticness` is highly correlated with `energy`	High correlation
`instrumentalness` is highly correlated with `genre`	High correlation
`artist` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`song` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`popularity` has 126 (6.3%) zeros	Zeros
`key` has 198 (9.9%) zeros	Zeros
`instrumentalness` has 1085 (54.2%) zeros	Zeros

Reproduction

Analysis started	2022-09-12 03:08:09.767588
Analysis finished	2022-09-12 03:08:43.648486
Duration	33.88 seconds
Software version	pandas-profiling v3.3.0
Download configuration	config.json

artist
Unsupported

REJECTED
UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	15.8 KiB

song
Unsupported

REJECTED
UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	15.8 KiB

duration_ms
Real number (ℝ_≥0)

Distinct	1790
Distinct (%)	89.6%
Missing	3
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	228750.1627

Minimum	113000
Maximum	484146
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	15.8 KiB

Quantile statistics

Minimum	113000
5-th percentile	174954.6
Q1	203520
median	223266
Q3	248133
95-th percentile	298870.4
Maximum	484146
Range	371146
Interquartile range (IQR)	44613

Descriptive statistics

Standard deviation	39164.93365
Coefficient of variation (CV)	0.1712127029
Kurtosis	3.305887399
Mean	228750.1627
Median Absolute Deviation (MAD)	21680
Skewness	1.01809728
Sum	456814075
Variance	1533892028
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
212106	4	0.2%
240040	3	0.1%
200106	3	0.1%
202066	3	0.1%
243533	3	0.1%
249533	3	0.1%
268866	3	0.1%
236133	3	0.1%
199480	3	0.1%
257200	3	0.1%
Other values (1780)	1966	98.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
113000	1	0.1%
114893	1	0.1%
119133	1	0.1%
121886	1	0.1%
124055	1	0.1%
126446	1	0.1%
127920	1	0.1%
129264	1	0.1%
131064	1	0.1%
131213	1	0.1%

Value	Count	Frequency (%)
484146	1	0.1%
452906	1	0.1%
448573	1	0.1%
444333	1	0.1%
432146	1	0.1%
417920	1	0.1%
404106	1	0.1%
393813	1	0.1%
366733	1	0.1%
359973	1	0.1%

explicit
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	0.1%
Missing	2
Missing (%)	0.1%
Memory size	15.8 KiB

0.0	1447
1.0	551

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	5994
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	1447	72.4%
1.0	551	27.6%
(Missing)	2	0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0.0	1447	72.4%
1.0	551	27.6%

Most occurring characters

Value	Count	Frequency (%)
0	3445	57.5%
.	1998	33.3%
1	551	9.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	3996	66.7%
Other Punctuation	1998	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	3445	86.2%
1	551	13.8%

Other Punctuation

Value	Count	Frequency (%)
.	1998	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	5994	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	3445	57.5%
.	1998	33.3%
1	551	9.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5994	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	3445	57.5%
.	1998	33.3%
1	551	9.2%

year
Real number (ℝ_≥0)

Distinct	23
Distinct (%)	1.2%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	2009.490245

Minimum	1998
Maximum	2020
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	15.8 KiB

Quantile statistics

Minimum	1998
5-th percentile	2000
Q1	2004
median	2010
Q3	2015
95-th percentile	2018
Maximum	2020
Range	22
Interquartile range (IQR)	11

Descriptive statistics

Standard deviation	5.859019372
Coefficient of variation (CV)	0.002915674453
Kurtosis	-1.194757502
Mean	2009.490245
Median Absolute Deviation (MAD)	5
Skewness	-0.04537927933
Sum	4016971
Variance	34.328108
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=23)

Value	Count	Frequency (%)
2012	115	5.8%
2017	110	5.5%
2001	108	5.4%
2010	107	5.3%
2018	107	5.3%
2014	104	5.2%
2005	104	5.2%
2011	99	5.0%
2016	99	5.0%
2015	99	5.0%
Other values (13)	947	47.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1998	1	0.1%
1999	38	1.9%
2000	74	3.7%
2001	108	5.4%
2002	90	4.5%
2003	97	4.9%
2004	96	4.8%
2005	104	5.2%
2006	95	4.8%
2007	94	4.7%

Value	Count	Frequency (%)
2020	3	0.1%
2019	89	4.5%
2018	107	5.3%
2017	110	5.5%
2016	99	5.0%
2015	99	5.0%
2014	104	5.2%
2013	89	4.5%
2012	115	5.8%
2011	99	5.0%

popularity
Real number (ℝ_≥0)

ZEROS

Distinct	76
Distinct (%)	3.8%
Missing	4
Missing (%)	0.2%
Infinite	0
Infinite (%)	0.0%
Mean	59.85220441

Minimum	0
Maximum	89
Zeros	126
Zeros (%)	6.3%
Negative	0
Negative (%)	0.0%
Memory size	15.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	56
median	65
Q3	73
95-th percentile	80
Maximum	89
Range	89
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	21.35163767
Coefficient of variation (CV)	0.3567393696
Kurtosis	2.645965134
Mean	59.85220441
Median Absolute Deviation (MAD)	8
Skewness	-1.821383915
Sum	119465
Variance	455.8924312
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	126	6.3%
69	76	3.8%
68	75	3.8%
73	69	3.5%
74	68	3.4%
67	66	3.3%
76	64	3.2%
64	63	3.1%
72	62	3.1%
57	62	3.1%
Other values (66)	1265	63.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	126	6.3%
1	31	1.6%
2	11	0.5%
3	5	0.2%
4	4	0.2%
6	1	0.1%
7	1	0.1%
8	1	0.1%
11	1	0.1%
16	1	0.1%

Value	Count	Frequency (%)
89	1	0.1%
88	1	0.1%
87	1	0.1%
86	4	0.2%
85	7	0.4%
84	11	0.5%
83	15	0.8%
82	25	1.2%
81	27	1.4%
80	43	2.1%

danceability
Real number (ℝ_≥0)

Distinct	565
Distinct (%)	28.3%
Missing	4
Missing (%)	0.2%
Infinite	0
Infinite (%)	0.0%
Mean	0.6673446894

Minimum	0.129
Maximum	0.975
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	15.8 KiB

Quantile statistics

Minimum	0.129
5-th percentile	0.4195
Q1	0.581
median	0.676
Q3	0.764
95-th percentile	0.886
Maximum	0.975
Range	0.846
Interquartile range (IQR)	0.183

Descriptive statistics

Standard deviation	0.1405145447
Coefficient of variation (CV)	0.2105576727
Kurtosis	0.1214117439
Mean	0.6673446894
Median Absolute Deviation (MAD)	0.091
Skewness	-0.4265341423
Sum	1332.02
Variance	0.01974433727
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.688	12	0.6%
0.736	12	0.6%
0.687	11	0.5%
0.791	11	0.5%
0.682	11	0.5%
0.656	10	0.5%
0.76	10	0.5%
0.794	10	0.5%
0.66	10	0.5%
0.68	10	0.5%
Other values (555)	1889	94.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.129	1	0.1%
0.177	1	0.1%
0.179	1	0.1%
0.18	1	0.1%
0.19	1	0.1%
0.209	1	0.1%
0.217	1	0.1%
0.23	1	0.1%
0.256	1	0.1%
0.259	1	0.1%

Value	Count	Frequency (%)
0.975	1	0.1%
0.97	1	0.1%
0.969	1	0.1%
0.967	1	0.1%
0.964	2	0.1%
0.963	2	0.1%
0.962	1	0.1%
0.956	1	0.1%
0.955	1	0.1%
0.951	1	0.1%

energy
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	580
Distinct (%)	29.0%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	0.7202966483

Minimum	0.0549
Maximum	0.999
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	15.8 KiB

Quantile statistics

Minimum	0.0549
5-th percentile	0.4429
Q1	0.622
median	0.736
Q3	0.839
95-th percentile	0.9331
Maximum	0.999
Range	0.9441
Interquartile range (IQR)	0.217

Descriptive statistics

Standard deviation	0.152752005
Coefficient of variation (CV)	0.2120681879
Kurtosis	0.1759961291
Mean	0.7202966483
Median Absolute Deviation (MAD)	0.108
Skewness	-0.632140422
Sum	1439.873
Variance	0.02333317503
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.783	15	0.8%
0.862	12	0.6%
0.768	11	0.5%
0.8	10	0.5%
0.791	10	0.5%
0.628	9	0.4%
0.861	9	0.4%
0.786	9	0.4%
0.921	9	0.4%
0.677	9	0.4%
Other values (570)	1896	94.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0549	1	0.1%
0.0581	1	0.1%
0.115	1	0.1%
0.203	1	0.1%
0.219	1	0.1%
0.247	1	0.1%
0.249	1	0.1%
0.261	1	0.1%
0.264	1	0.1%
0.265	1	0.1%

Value	Count	Frequency (%)
0.999	1	0.1%
0.988	1	0.1%
0.985	1	0.1%
0.984	1	0.1%
0.982	1	0.1%
0.981	1	0.1%
0.979	1	0.1%
0.978	1	0.1%
0.977	2	0.1%
0.976	3	0.1%

key
Real number (ℝ_≥0)

ZEROS

Distinct	12
Distinct (%)	0.6%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	5.378189095

Minimum	0
Maximum	11
Zeros	198
Zeros (%)	9.9%
Negative	0
Negative (%)	0.0%
Memory size	15.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	6
Q3	8
95-th percentile	11
Maximum	11
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.61595349
Coefficient of variation (CV)	0.6723366223
Kurtosis	-1.298666178
Mean	5.378189095
Median Absolute Deviation (MAD)	3
Skewness	-0.009533483866
Sum	10751
Variance	13.07511964
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
1	267	13.4%
11	199	10.0%
0	198	9.9%
7	197	9.8%
5	181	9.0%
8	173	8.6%
2	158	7.9%
9	157	7.8%
6	154	7.7%
10	129	6.5%
Other values (2)	186	9.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	198	9.9%
1	267	13.4%
2	158	7.9%
3	60	3.0%
4	126	6.3%
5	181	9.0%
6	154	7.7%
7	197	9.8%
8	173	8.6%
9	157	7.8%

Value	Count	Frequency (%)
11	199	10.0%
10	129	6.5%
9	157	7.8%
8	173	8.6%
7	197	9.8%
6	154	7.7%
5	181	9.0%
4	126	6.3%
3	60	3.0%
2	158	7.9%

loudness
Real number (ℝ)

HIGH CORRELATION

Distinct	1669
Distinct (%)	83.5%
Missing	2
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	-4992.963732

Minimum	-20514
Maximum	-0.276
Zeros	0
Zeros (%)	0.0%
Negative	1998
Negative (%)	99.9%
Memory size	15.8 KiB

Quantile statistics

Minimum	-20514
5-th percentile	-8728.2
Q1	-6336
median	-5076.5
Q3	-3836.75
95-th percentile	-5.3455
Maximum	-0.276
Range	20513.724
Interquartile range (IQR)	2499.25

Descriptive statistics

Standard deviation	2429.823923
Coefficient of variation (CV)	-0.486649624
Kurtosis	1.821564258
Mean	-4992.963732
Median Absolute Deviation (MAD)	1245.5
Skewness	-0.08886108204
Sum	-9975941.536
Variance	5904044.296
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-6366	5	0.2%
-5595	4	0.2%
-3782	4	0.2%
-5153	4	0.2%
-5096	3	0.1%
-3078	3	0.1%
-4315	3	0.1%
-5611	3	0.1%
-5892	3	0.1%
-3887	3	0.1%
Other values (1659)	1963	98.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-20514	1	0.1%
-17217	1	0.1%
-15636	1	0.1%
-14505	1	0.1%
-13964	1	0.1%
-13744	1	0.1%
-13609	1	0.1%
-13203	1	0.1%
-12932	1	0.1%
-12852	1	0.1%

Value	Count	Frequency (%)
-0.276	1	0.1%
-0.74	1	0.1%
-1.19	1	0.1%
-1.73	1	0.1%
-2.18	2	0.1%
-2.28	1	0.1%
-2.36	1	0.1%
-2.61	1	0.1%
-2.69	1	0.1%
-2.76	1	0.1%

mode
Categorical

Distinct	2
Distinct (%)	0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	15.8 KiB

1.0	1107
0.0	892

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	5997
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	1.0
3rd row	1.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
1.0	1107	55.4%
0.0	892	44.6%
(Missing)	1	0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
1.0	1107	55.4%
0.0	892	44.6%

Most occurring characters

Value	Count	Frequency (%)
0	2891	48.2%
.	1999	33.3%
1	1107	18.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	3998	66.7%
Other Punctuation	1999	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	2891	72.3%
1	1107	27.7%

Other Punctuation

Value	Count	Frequency (%)
.	1999	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	5997	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	2891	48.2%
.	1999	33.3%
1	1107	18.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5997	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	2891	48.2%
.	1999	33.3%
1	1107	18.5%

speechiness
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	836
Distinct (%)	41.8%
Missing	2
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	0.1036066066

Minimum	0.0232
Maximum	0.576
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	15.8 KiB

Quantile statistics

Minimum	0.0232
5-th percentile	0.029
Q1	0.0396
median	0.05985
Q3	0.129
95-th percentile	0.322
Maximum	0.576
Range	0.5528
Interquartile range (IQR)	0.0894

Descriptive statistics

Standard deviation	0.09619269207
Coefficient of variation (CV)	0.9284416817
Kurtosis	2.620774903
Mean	0.1036066066
Median Absolute Deviation (MAD)	0.02645
Skewness	1.760789253
Sum	207.006
Variance	0.009253034007
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0432	13	0.7%
0.029	12	0.6%
0.0322	11	0.5%
0.0363	10	0.5%
0.109	9	0.4%
0.0439	9	0.4%
0.0377	8	0.4%
0.108	8	0.4%
0.046	8	0.4%
0.0431	8	0.4%
Other values (826)	1902	95.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0232	1	0.1%
0.0239	1	0.1%
0.0241	1	0.1%
0.0242	1	0.1%
0.0245	2	0.1%
0.0247	1	0.1%
0.0249	2	0.1%
0.0252	2	0.1%
0.0253	2	0.1%
0.0255	2	0.1%

Value	Count	Frequency (%)
0.576	1	0.1%
0.53	1	0.1%
0.516	1	0.1%
0.505	1	0.1%
0.488	1	0.1%
0.484	1	0.1%
0.483	1	0.1%
0.478	1	0.1%
0.47	1	0.1%
0.467	1	0.1%

acousticness
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1208
Distinct (%)	60.5%
Missing	4
Missing (%)	0.2%
Infinite	0
Infinite (%)	0.0%
Mean	0.1291619519

Minimum	1.92 × 10^-5
Maximum	0.976
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	15.8 KiB

Quantile statistics

Minimum	1.92 × 10^-5
5-th percentile	0.0009825
Q1	0.013925
median	0.05585
Q3	0.177
95-th percentile	0.515
Maximum	0.976
Range	0.9759808
Interquartile range (IQR)	0.163075

Descriptive statistics

Standard deviation	0.1734572072
Coefficient of variation (CV)	1.342943527
Kurtosis	4.651408522
Mean	0.1291619519
Median Absolute Deviation (MAD)	0.05115
Skewness	2.091152906
Sum	257.8072559
Variance	0.03008740272
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.15	7	0.4%
0.107	7	0.4%
0.23	7	0.4%
0.191	6	0.3%
0.157	6	0.3%
0.106	6	0.3%
0.109	6	0.3%
0.123	6	0.3%
0.0192	6	0.3%
0.102	6	0.3%
Other values (1198)	1933	96.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.92 × 10^-5	1	0.1%
2.06 × 10^-5	1	0.1%
2.64 × 10^-5	1	0.1%
3.82 × 10^-5	1	0.1%
4.14 × 10^-5	1	0.1%
5.15 × 10^-5	1	0.1%
5.48 × 10^-5	1	0.1%
6.52 × 10^-5	1	0.1%
6.79 × 10^-5	1	0.1%
7.95 × 10^-5	1	0.1%

Value	Count	Frequency (%)
0.976	1	0.1%
0.966	1	0.1%
0.953	1	0.1%
0.945	1	0.1%
0.934	2	0.1%
0.932	1	0.1%
0.922	1	0.1%
0.896	1	0.1%
0.893	1	0.1%
0.883	1	0.1%

instrumentalness
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	772
Distinct (%)	38.6%
Missing	2
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	0.01524123184

Minimum	0
Maximum	0.985
Zeros	1085
Zeros (%)	54.2%
Negative	0
Negative (%)	0.0%
Memory size	15.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	6.89 × 10^-5
95-th percentile	0.034515
Maximum	0.985
Range	0.985
Interquartile range (IQR)	6.89 × 10^-5

Descriptive statistics

Standard deviation	0.08781333857
Coefficient of variation (CV)	5.761564388
Kurtosis	61.40423073
Mean	0.01524123184
Median Absolute Deviation (MAD)	0
Skewness	7.577776056
Sum	30.45198121
Variance	0.007711182431
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1085	54.2%
0.0013	3	0.1%
0.000108	3	0.1%
0.000139	3	0.1%
0.000113	3	0.1%
8.83 × 10^-6	3	0.1%
1.96 × 10^-6	3	0.1%
2.77 × 10^-6	3	0.1%
0.000157	3	0.1%
1.81 × 10^-6	3	0.1%
Other values (762)	886	44.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1085	54.2%
1.01 × 10^-6	1	0.1%
1.03 × 10^-6	3	0.1%
1.04 × 10^-6	1	0.1%
1.07 × 10^-6	1	0.1%
1.1 × 10^-6	1	0.1%
1.11 × 10^-6	3	0.1%
1.13 × 10^-6	1	0.1%
1.16 × 10^-6	2	0.1%
1.2 × 10^-6	1	0.1%

Value	Count	Frequency (%)
0.985	1	0.1%
0.925	1	0.1%
0.901	1	0.1%
0.894	1	0.1%
0.828	1	0.1%
0.812	1	0.1%
0.809	1	0.1%
0.799	1	0.1%
0.792	1	0.1%
0.751	1	0.1%

liveness
Real number (ℝ_≥0)

Distinct	782
Distinct (%)	39.1%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	0.1812956978

Minimum	0.0234
Maximum	0.853
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	15.8 KiB

Quantile statistics

Minimum	0.0234
5-th percentile	0.05169
Q1	0.08815
median	0.124
Q3	0.241
95-th percentile	0.4606
Maximum	0.853
Range	0.8296
Interquartile range (IQR)	0.15285

Descriptive statistics

Standard deviation	0.1406590055
Coefficient of variation (CV)	0.7758540723
Kurtosis	3.831954855
Mean	0.1812956978
Median Absolute Deviation (MAD)	0.0504
Skewness	1.848935403
Sum	362.4101
Variance	0.01978495582
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.104	25	1.2%
0.111	23	1.1%
0.107	20	1.0%
0.108	19	0.9%
0.118	19	0.9%
0.112	18	0.9%
0.106	17	0.9%
0.105	16	0.8%
0.101	15	0.8%
0.124	15	0.8%
Other values (772)	1812	90.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0234	1	0.1%
0.0241	1	0.1%
0.0263	1	0.1%
0.0272	1	0.1%
0.028	1	0.1%
0.0283	2	0.1%
0.0286	1	0.1%
0.0288	2	0.1%
0.029	1	0.1%
0.0304	1	0.1%

Value	Count	Frequency (%)
0.853	1	0.1%
0.843	1	0.1%
0.839	1	0.1%
0.833	1	0.1%
0.826	1	0.1%
0.82	1	0.1%
0.817	1	0.1%
0.801	1	0.1%
0.795	1	0.1%
0.775	1	0.1%

valence
Real number (ℝ_≥0)

Distinct	760
Distinct (%)	38.0%
Missing	2
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	0.5515346847

Minimum	0.0381
Maximum	0.973
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	15.8 KiB

Quantile statistics

Minimum	0.0381
5-th percentile	0.1737
Q1	0.38625
median	0.5575
Q3	0.73
95-th percentile	0.895
Maximum	0.973
Range	0.9349
Interquartile range (IQR)	0.34375

Descriptive statistics

Standard deviation	0.2208111539
Coefficient of variation (CV)	0.4003576929
Kurtosis	-0.8221086212
Mean	0.5515346847
Median Absolute Deviation (MAD)	0.1715
Skewness	-0.1293595051
Sum	1101.9663
Variance	0.0487575657
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.418	11	0.5%
0.74	9	0.4%
0.527	8	0.4%
0.4	8	0.4%
0.801	8	0.4%
0.446	8	0.4%
0.272	7	0.4%
0.716	7	0.4%
0.554	7	0.4%
0.586	7	0.4%
Other values (750)	1918	95.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0381	1	0.1%
0.0406	1	0.1%
0.0594	1	0.1%
0.0596	1	0.1%
0.0681	1	0.1%
0.0694	1	0.1%
0.0756	1	0.1%
0.0783	1	0.1%
0.0784	1	0.1%
0.0789	1	0.1%

Value	Count	Frequency (%)
0.973	2	0.1%
0.972	2	0.1%
0.969	1	0.1%
0.968	1	0.1%
0.966	4	0.2%
0.965	3	0.1%
0.964	4	0.2%
0.963	2	0.1%
0.962	5	0.2%
0.961	4	0.2%

tempo
Real number (ℝ_≥0)

Distinct	1828
Distinct (%)	91.5%
Missing	3
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	107236.0186

Minimum	75.09
Maximum	210851
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	15.8 KiB

Quantile statistics

Minimum	75.09
5-th percentile	117.248
Q1	93023
median	116044
Q3	131059
95-th percentile	171373.4
Maximum	210851
Range	210775.91
Interquartile range (IQR)	38036

Descriptive statistics

Standard deviation	45263.83167
Coefficient of variation (CV)	0.4220954138
Kurtosis	1.023432492
Mean	107236.0186
Median Absolute Deviation (MAD)	20201
Skewness	-1.037539384
Sum	214150329.2
Variance	2048814457
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
140022	4	0.2%
130	3	0.1%
100011	3	0.1%
97954	3	0.1%
120003	3	0.1%
91.03	3	0.1%
143994	3	0.1%
121996	3	0.1%
128008	3	0.1%
83066	3	0.1%
Other values (1818)	1966	98.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
75.09	1	0.1%
76	1	0.1%
76.91	1	0.1%
77.49	1	0.1%
79.01	1	0.1%
80	1	0.1%
82.48	1	0.1%
82.82	1	0.1%
82.92	1	0.1%
83.46	1	0.1%

Value	Count	Frequency (%)
210851	1	0.1%
203911	1	0.1%
203862	1	0.1%
202015	1	0.1%
201936	1	0.1%
199958	1	0.1%
199935	1	0.1%
199764	1	0.1%
198075	1	0.1%
198065	1	0.1%

genre
Categorical

HIGH CARDINALITY
HIGH CORRELATION

Distinct	59
Distinct (%)	3.0%
Missing	2
Missing (%)	0.1%
Memory size	15.8 KiB

pop	427
hip hop, pop	277
hip hop, pop, R&B	244
pop, Dance/Electronic	221
pop, R&B	178
Other values (54)	651

Length

Max length	37
Median length	32
Mean length	11.88688689
Min length	3

Characters and Unicode

Total characters	23750
Distinct characters	35
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	18 ?
Unique (%)	0.9%

Sample

1st row	pop
2nd row	rock, pop
3rd row	pop, country
4th row	rock, metal
5th row	pop

Common Values

Value	Count	Frequency (%)
pop	427	21.3%
hip hop, pop	277	13.9%
hip hop, pop, R&B	244	12.2%
pop, Dance/Electronic	221	11.1%
pop, R&B	178	8.9%
hip hop	124	6.2%
hip hop, pop, Dance/Electronic	78	3.9%
rock	57	2.9%
rock, pop	43	2.1%
Dance/Electronic	41	2.1%
Other values (49)	308	15.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
pop	1632	36.4%
hip	778	17.3%
hop	778	17.3%
r&b	452	10.1%
dance/electronic	390	8.7%
rock	233	5.2%
metal	66	1.5%
latin	64	1.4%
set	22	0.5%
country	21	0.5%
Other values (7)	51	1.1%

Most occurring characters

Value	Count	Frequency (%)
p	4820	20.3%
o	3114	13.1%
	2489	10.5%
,	1704	7.2%
h	1556	6.6%
c	1466	6.2%
i	1287	5.4%
n	889	3.7%
e	886	3.7%
r	664	2.8%
Other values (25)	4875	20.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	16897	71.1%
Other Punctuation	2576	10.8%
Space Separator	2489	10.5%
Uppercase Letter	1744	7.3%
Close Punctuation	22	0.1%
Open Punctuation	22	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
p	4820	28.5%
o	3114	18.4%
h	1556	9.2%
c	1466	8.7%
i	1287	7.6%
n	889	5.3%
e	886	5.2%
r	664	3.9%
t	600	3.6%
l	573	3.4%
Other values (11)	1042	6.2%

Uppercase Letter

Value	Count	Frequency (%)
B	452	25.9%
R	452	25.9%
E	390	22.4%
D	390	22.4%
F	20	1.1%
A	20	1.1%
W	10	0.6%
T	10	0.6%

Other Punctuation

Value	Count	Frequency (%)
,	1704	66.1%
&	452	17.5%
/	420	16.3%

Space Separator

Value	Count	Frequency (%)
	2489	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	22	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	22	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	18641	78.5%
Common	5109	21.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
p	4820	25.9%
o	3114	16.7%
h	1556	8.3%
c	1466	7.9%
i	1287	6.9%
n	889	4.8%
e	886	4.8%
r	664	3.6%
t	600	3.2%
l	573	3.1%
Other values (19)	2786	14.9%

Common

Value	Count	Frequency (%)
	2489	48.7%
,	1704	33.4%
&	452	8.8%
/	420	8.2%
)	22	0.4%
(	22	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	23750	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
p	4820	20.3%
o	3114	13.1%
	2489	10.5%
,	1704	7.2%
h	1556	6.6%
c	1466	6.2%
i	1287	5.4%
n	889	3.7%
e	886	3.7%
r	664	2.8%
Other values (25)	4875	20.5%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	artist	song	duration_ms	explicit	year	popularity	danceability	energy	key	loudness	mode	speechiness	acousticness	instrumentalness	liveness	valence	tempo	genre
0	Britney Spears	Oops!...I Did It Again	211160.0	0.0	2000.0	77.0	0.751	0.834	1.0	-5444.0	0.0	0.0437	0.30000	0.000018	0.3550	0.894	95053.0	pop
1	blink-182	All The Small Things	167066.0	0.0	1999.0	79.0	0.434	0.897	0.0	-4918.0	1.0	0.0488	0.01030	0.000000	0.6120	0.684	148726.0	rock, pop
2	Faith Hill	Breathe	250546.0	0.0	1999.0	66.0	0.529	0.496	7.0	-9007.0	1.0	0.0290	0.17300	0.000000	0.2510	0.278	136859.0	pop, country
3	Bon Jovi	It's My Life	224493.0	0.0	2000.0	78.0	0.551	0.913	0.0	-4063.0	0.0	0.0466	0.02630	0.000013	0.3470	0.544	119992.0	rock, metal
4	*NSYNC	Bye Bye Bye	200560.0	0.0	2000.0	NaN	0.614	0.928	8.0	-4806.0	0.0	0.0516	0.04080	0.001040	0.0845	0.879	172656.0	pop
5	Sisqo	Thong Song	253733.0	1.0	1999.0	69.0	0.706	0.888	2.0	-6959.0	1.0	0.0654	0.11900	0.000096	0.0700	0.714	121549.0	hip hop, pop, R&B
6	Eminem	The Real Slim Shady	284200.0	1.0	2000.0	86.0	0.949	0.661	5.0	-4244.0	0.0	0.0572	0.03020	0.000000	0.0454	0.760	104504.0	hip hop
7	Robbie Williams	Rock DJ	258560.0	0.0	2000.0	68.0	0.708	0.772	7.0	-4264.0	1.0	0.0322	0.02670	0.000000	0.4670	0.861	103035.0	pop, rock
8	Destiny's Child	Say My Name	271333.0	0.0	1999.0	75.0	0.713	0.678	5.0	-3525.0	0.0	0.1020	0.27300	0.000000	0.1490	0.734	138009.0	pop, R&B
9	Modjo	Lady - Hear Me Tonight	307153.0	0.0	2001.0	77.0	0.720	0.808	6.0	-5627.0	1.0	0.0379	0.00793	0.029300	0.0634	0.869	126041.0	Dance/Electronic

Last rows

	artist	song	duration_ms	explicit	year	popularity	danceability	energy	key	loudness	mode	speechiness	acousticness	instrumentalness	liveness	valence	tempo	genre
1990	Sam Smith	How Do You Sleep?	202204.0	0.0	2019.0	73.0	0.477	0.682	1.0	-4931.0	0.0	0.0925	0.1530	0.000000	0.0763	0.345	110567.0	pop
1991	NSG	Options	240081.0	1.0	2020.0	57.0	0.836	0.621	1.0	-4684.0	0.0	0.0894	0.3890	0.000092	0.1040	0.762	101993.0	World/Traditional, hip hop
1992	Normani	Motivation	193837.0	0.0	2019.0	71.0	0.599	0.887	4.0	-3967.0	1.0	0.0984	0.0192	0.000001	0.3000	0.881	170918.0	pop, R&B
1993	Joel Corry	Sorry	188640.0	0.0	2019.0	63.0	0.744	0.790	8.0	-4617.0	0.0	0.0562	0.0547	0.000802	0.3200	0.847	125002.0	pop, Dance/Electronic
1994	Post Malone	Goodbyes (Feat. Young Thug)	174960.0	1.0	2019.0	1.0	0.580	0.653	5.0	-3818.0	1.0	0.0745	0.4470	0.000000	0.1110	0.175	150231.0	hip hop
1995	Jonas Brothers	Sucker	181026.0	0.0	2019.0	79.0	0.842	0.734	1.0	-5065.0	0.0	0.0588	0.0427	0.000000	0.1060	0.952	137958.0	pop
1996	Taylor Swift	Cruel Summer	178426.0	0.0	2019.0	78.0	0.552	0.702	9.0	-5707.0	1.0	0.1570	0.1170	0.000021	0.1050	0.564	169994.0	pop
1997	Blanco Brown	The Git Up	200593.0	0.0	2019.0	69.0	0.847	0.678	9.0	-8635.0	1.0	0.1090	0.0669	0.000000	0.2740	0.811	NaN	hip hop, country
1998	Sam Smith	Dancing With A Stranger (with Normani)	171029.0	0.0	2019.0	75.0	0.741	0.520	8.0	-7513.0	1.0	0.0656	0.4500	0.000002	0.2220	0.347	102998.0	pop
1999	Post Malone	Circles	215280.0	0.0	2019.0	85.0	0.695	0.762	0.0	-3497.0	1.0	0.0395	0.1920	0.002440	0.0863	0.553	120042.0	hip hop

Most frequently occurring

	duration_ms	explicit	year	popularity	danceability	energy	key	loudness	mode	speechiness	acousticness	instrumentalness	liveness	valence	tempo	genre	# duplicates
0	177184.0	1.0	2016.0	76.0	0.886	0.427	6.0	-10028.0	1.0	0.1450	0.031200	0.000990	0.0906	0.230	108034.0	hip hop	2
1	177685.0	1.0	2013.0	56.0	0.760	0.652	6.0	-7321.0	1.0	0.2320	0.034800	0.000000	0.3070	0.759	100315.0	hip hop, pop	2
2	184573.0	0.0	2010.0	66.0	0.799	0.783	1.0	-3896.0	0.0	0.0322	0.034600	0.018600	0.0757	0.586	127041.0	pop	2
3	192190.0	0.0	2015.0	76.0	0.688	0.702	7.0	-4792.0	0.0	0.0499	0.021500	0.000000	0.1280	0.740	94006.0	hip hop, pop	2
4	193653.0	0.0	2005.0	65.0	0.469	0.955	10.0	-4253.0	1.0	0.0432	0.000343	0.000001	0.5480	0.462	143853.0	rock, pop	2
5	195200.0	0.0	2015.0	75.0	0.526	0.862	2.0	-6003.0	1.0	0.0905	0.014400	0.059700	0.2290	0.528	90052.0	hip hop, rock, pop	2
6	198293.0	1.0	2015.0	78.0	0.765	0.356	11.0	-5556.0	0.0	0.1950	0.223000	0.000000	0.0963	0.189	96991.0	hip hop, pop, R&B	2
7	199480.0	0.0	2011.0	67.0	0.707	0.861	7.0	-4225.0	1.0	0.3160	0.100000	0.000000	0.1910	0.795	130021.0	hip hop, pop, Dance/Electronic	2
8	200185.0	0.0	2018.0	86.0	0.351	0.296	4.0	-10109.0	0.0	0.0333	0.934000	0.000000	0.0950	0.120	115284.0	pop, Dance/Electronic	2
9	200786.0	0.0	2015.0	80.0	0.654	0.760	0.0	-3669.0	0.0	0.0450	0.079700	0.000000	0.2990	0.410	99945.0	pop	2

Overview

Variables

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Space Separator

Close Punctuation

Open Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Cramér's V (φc)

Phik (φk)

Missing values

Sample

First rows

Last rows

Duplicate rows

Most frequently occurring